package net.ojbk.study.twobox.dao;

import net.ojbk.study.twobox.beans.po.Student;
import net.ojbk.study.twobox.beans.vo.JoinJob;
import net.ojbk.study.twobox.beans.vo.SelectOption;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface StudentMapper extends Mapper<Student> {
    @Select("SELECT id id, className `name` FROM crm_class")
    public List<SelectOption> getAllClass();

    @Select("SELECT id id, stuname `stuname`, stusex `stusex`, classid `classid` FROM crm_student WHERE classid = #{classId} AND stuState != '刚入职'")
    public List<JoinJob> getAll_JoinJob_ByClassId(int classId);

}
